Friday, April 04, 2025

New FirebirdSQL engine feature : Range-based FOR statement



Here is the description :

"The range-based FOR statement is used to iterate over a range of numeric values. The iteration is performed in increasing order when used with TO clause and in decreasing order when used with DOWNTO clause"

Syntax

[<label> :] 
 FOR <variable> = <initial value> {TO | DOWNTO} <final value> [BY <by value>] DO
          <statement>


Discussion on the Firebird-devel is here
Update: Feature already merged.

No comments: